package net.trustie.dao;

import net.trustie.model.openhub_Model;

import org.apache.ibatis.annotations.Insert;

public interface OpenHubProject_Dao {
//	
//	
//	@Insert("insert into openhub_project_new"
//			+"(`name`,`url`,`activity`,`followers_num`,`description`,`tags`,`organization`,`projectLinks`,`codeLocation`,"
//			+ "`license`,`similarProjects`,`managers`,`commitNum`,`contributorNum`,`codeLinesNum`,`mostWrittenIn`,"
//			+ "`commentsPercentage`,`codebaseStatus`,`teamScale`,`commitStatus`,`estimateEffortTime`,"
//			/*`last_update_time`,*/+ "`firstCommitTime`,`languagePercentages`,`activityDayTime`,`daysCommitNumber`,"
//			+ "`daysContributorNumber`,`newContributor`,`newContriNum`,`activityMonthTime`,`monthsCommitNumber`,"
//			+ "`monthsContributorNumber`,`theCommitTrend`,`theContriTrend`,`rateLevel`,`extractTime`,`homepage`)"
//			
//	+" values (#{name},#{projectUrl},#{activity},#{useCount},#{description},#{tags},#{organization},"
//	+ "#{projectLinks},#{codeLocation},#{licenses},#{similarProjects},#{managers},#{commitNum},"
//	+ "#{contributorNum},#{codeLinesNum},#{mostWrittenIn},#{commentsPercentage},#{codebaseStatus},"
//	/*#{lastCommitTime},*/+ "#{teamScale},#{commitStatus},#{estimateEffortTime},#{firstCommitTime},#{languagePercentages},"
//	+ "#{activityDayTime},#{daysCommitNumber},#{daysContributorNumber},#{newContributor},#{newContriNum},"
//	+ "#{activityMonthTime},#{monthsCommitNumber},#{monthsContributorNumber},#{theCommitTrend},"
//	+ "#{theContriTrend},#{rateLevel},#{extractTime},#{homepage})") 

	
	
	@Insert("insert into openhub_project"
			+"(`url_md5`,`source`,`name`,`url`,`user_num`,`description`,`tags`,`organization`,"
			+ "`license`,`similar_project`,`manager`,"
			+ "`language`,`active_degree`,"
			+ "`code_repository`,"
			+ "`created_time`,`rate_num`,`rate_value`,`extracted_time`,`homepage`)"
			
	+" values (#{urlMd5},#{source},#{name},#{projectUrl},#{useCount},#{description},#{tags},#{organization},"
	+ "#{licenses},#{similarProjects},#{managers},"
	/*#{lastCommitTime},*/+ "#{languagePercentages},#{activity},"
	+ "#{projectLinks},"
	+ "#{firstCommitTime},#{rateNum},#{rateLevel},#{extractTime},#{homepage})") 		
			public int add(openhub_Model OpHmodel);
}
